"192.168.0.1:sipop" Previous topic Chapter index Next topic

TIPODOCUMENTO

 

 

Descriptions

TIPO DE DOCUMENTO DE REGISTRO EN EL SISTEMA

 

Fields

PK

FK

Name

Domain

Data type

Not null

Default

Description

 

ID_TIPO_DOCUMENTO

 

CHAR (3)

 

Tipo de documento de registro

 

 

NOMBRE

 

CHAR (30)

 

Nombre del documento de registro

 

 

DESCRIPCION

 

CHAR (30)

 

 

 

Triggers

Trigger

Type

Active

Position

Description

TIPODOCUMENTO_BI

Before Insert

0

 

 

Indices

There are no indices for table TIPODOCUMENTO

 

References

There are no references for table TIPODOCUMENTO

 

Referenced

Table

Foreign Key

Fields

FK Fields

DEL Rule

UPD Rule

REGISTRODEINGRESO

INTEG_286

TIPODOCUMENTO

ID_TIPO_DOCUMENTO

RESTRICT

RESTRICT

REGISTRODEINGRESOHQ

INTEG_242

TIPODOCUMENTO

ID_TIPO_DOCUMENTO

RESTRICT

RESTRICT

 

Definition


CREATE TABLE TIPODOCUMENTO (
    ID_TIPO_DOCUMENTO CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DESCRIPCION CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE TIPODOCUMENTO ADD PRIMARY KEY (ID_TIPO_DOCUMENTO);

    This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m. Previous topic Chapter index Next topic